﻿if exists (select * from sysobjects where name like N'%sp_DMLoaiTienTe_Insert%')
	drop proc sp_DMLoaiTienTe_Insert
go
create proc sp_DMLoaiTienTe_Insert
	@MaLoaiTienTe int = null,
	@TenLoaiTienTe nvarchar(50) = null,
	@IsUse bit = null,
	@CreateBy int = null,
	@ModifiedBy int = null,
	@ModifiedOn datetime = null
as
begin
	if not exists (select * from DMLoaiTienTe where MaLoaiTienTe = @MaLoaiTienTe)
	begin
		insert into DMLoaiTienTe (TenLoaiTienTe, IsUse, CreateBy)
		values (@TenLoaiTienTe, @IsUse, @CreateBy)
	end
end